UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3lqYuEbWOYAfAKY74XcTenEoBVPg5s2nA1BbyFIFFy8='
WHERE
key_id = 'fa25aab533e7e6a5a3f2088f700b4c60abe8929822e2cdba1b394b295b7b7ce3'
AND (
token = '3lqYuEbWOYAfAKY74XcTenEoBVPg5s2nA1BbyFIFFy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)