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