UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dEjyYhB16OTps08Kptw9wB0U2DZlsAYs1lp1oOoibqw='
WHERE
key_id = '18a3c563150aa8f6bcc1442ef00fd8292989f06a0c077af60285783065a0134a'
AND (
token = 'dEjyYhB16OTps08Kptw9wB0U2DZlsAYs1lp1oOoibqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)