UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BDlUskhPPOCembKdPJxj8u7P+PgADEeVGc+wO62yNEY='
WHERE
key_id = 'c059224f7ec7666737755260160ae33c06a10d5ffc8f1fabd8eaaf99b4a6fd8c'
AND (
token = 'BDlUskhPPOCembKdPJxj8u7P+PgADEeVGc+wO62yNEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)