UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DW7P+5k4HRlibkNV+fa1NN5asVoPKEjV168pT1j8AYc='
WHERE
key_id = 'bd4c221e976154416705fe7fb07881b056a70688011da8625a74302931492839'
AND (
token = 'DW7P+5k4HRlibkNV+fa1NN5asVoPKEjV168pT1j8AYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)