UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KIfIB/rMH96tskXSpYf52FddhMdo9xdTmZGgfKR/ldI='
WHERE
key_id = 'cb3117ad3c09b34bfb0435af811adeee611383c9e802da9932bd0b5bca6f4170'
AND (
token = 'KIfIB/rMH96tskXSpYf52FddhMdo9xdTmZGgfKR/ldI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)