UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Uo4WPq+Pxvfalq9X+y4KVFgq7k7mbuxCJTt3qUH5s48='
WHERE
key_id = 'a6ae07e363a95177ca902801f1e3252486871cd7506638618dacfe090a3c8a49'
AND (
token = 'Uo4WPq+Pxvfalq9X+y4KVFgq7k7mbuxCJTt3qUH5s48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)