UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDBsPhkChqSqv5SV+W4xCw5/MF18YjWofl59p1gKqT4='
WHERE
key_id = '49f3c9ef93b3b52954d696a44945d42733ca9ec7f21b3b9080141913a2685e5b'
AND (
token = 'ZDBsPhkChqSqv5SV+W4xCw5/MF18YjWofl59p1gKqT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)