UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0XyF7nvoh6ZaYZHAZzdqSBKWItbhQAbWgFAnJDMxBAY='
WHERE
key_id = 'b48d43fc58b54db8a7db70cbb5997fa1401d00b7711fc9c1b47fd8a6b21f672e'
AND (
token = '0XyF7nvoh6ZaYZHAZzdqSBKWItbhQAbWgFAnJDMxBAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)