UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dRAUKvj1D8OYY2wMztqEsP3sSX+/lGCyoKcc3aOaoUU='
WHERE
key_id = 'f5703f42a118324d759174388d819ea8179fcfc841843c58585da447a36afde7'
AND (
token = 'dRAUKvj1D8OYY2wMztqEsP3sSX+/lGCyoKcc3aOaoUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)