UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OsX8UgGQw2YCbWPunyiKcYqXQDB88aB8cZ9c7n68ol8='
WHERE
key_id = 'ddc88a1172726b9b533b02b45941d1e49f71c4e52e4c5f30bc426b15c964ef2b'
AND (
token = 'OsX8UgGQw2YCbWPunyiKcYqXQDB88aB8cZ9c7n68ol8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)