UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6oUTbFEdVPcVy3HnPIQFODEWlLAbdlDi8YpoZb8BASM='
WHERE
key_id = '29c151c4d707184f3094988f19287fcc64eb860b88a5781c322e69b8d4bff1eb'
AND (
token = '6oUTbFEdVPcVy3HnPIQFODEWlLAbdlDi8YpoZb8BASM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)