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