UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jD2IHFo7cp7aUk5eKbWdlYQ5j0R5RqWHFG+FllLeaak='
WHERE
key_id = 'e220c371087fc78e5207331a722eb86f25881f60108e0792c3417babe1f72fb6'
AND (
token = 'jD2IHFo7cp7aUk5eKbWdlYQ5j0R5RqWHFG+FllLeaak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)