UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BFZNNHrWtOjMsifnTcBa2NTSHk8Lj3/zmvHabir3/U='
WHERE
key_id = '678d19a2424a09014164ccb9aa51410066c51ac00733b4302db76c3f19d5df79'
AND (
token = '5BFZNNHrWtOjMsifnTcBa2NTSHk8Lj3/zmvHabir3/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)