UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ruPFgAoL/O9yMdw7hBZJajAY8rLqeYmEC0b8oiYNkHk='
WHERE
key_id = '8f27ea2917f80bc39a714b850e4a143e786994d7f239daee00a6b651fd6bb5cb'
AND (
token = 'ruPFgAoL/O9yMdw7hBZJajAY8rLqeYmEC0b8oiYNkHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)