UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JKI1mBRg9KDiFkN5NhGJZWJx8wWMDWfdRj9k9iNZpY='
WHERE
key_id = '9105c5a30dc795783fd974592095e0b4d7546098f3fb154c0fdb38e419581ad9'
AND (
token = '8JKI1mBRg9KDiFkN5NhGJZWJx8wWMDWfdRj9k9iNZpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)