UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsUNcLV8CuZA35HgTVoqq8uyaFyQlVblvEvyK9U/K/I='
WHERE
key_id = '464170a3815afda6b6d8670913e7df39083ffbd5c362488c87646f752db765f5'
AND (
token = 'ZsUNcLV8CuZA35HgTVoqq8uyaFyQlVblvEvyK9U/K/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)