UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xq779rAvNJix4Zmyx1QB0Z/P7y7zc1qzXFvTezkjKyA='
WHERE
key_id = 'e62f6c7eb7fbb3ecf3a6b971651aea84fe75ea9e33646bb733529b5904312ee2'
AND (
token = 'Xq779rAvNJix4Zmyx1QB0Z/P7y7zc1qzXFvTezkjKyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)