UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQiuRjvCB6Ij4rOP1VtSahc4QUy2MF/55l8U7wL5/u0='
WHERE
key_id = 'a7dc4d6735978faa0ec1a97648419c7457bd7f4eb6a71d0109ef6216cdba0c4f'
AND (
token = 'CQiuRjvCB6Ij4rOP1VtSahc4QUy2MF/55l8U7wL5/u0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)