UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sK5vNaL1FtdWVdLdLnw6YSdtsHxDw8LjoMZf92ZJg20='
WHERE
key_id = 'd8808a2d8abc9216cd5493bccba5ee43ada23ef0d45f0848d4eea74d1bccd145'
AND (
token = 'sK5vNaL1FtdWVdLdLnw6YSdtsHxDw8LjoMZf92ZJg20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)