UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gX9pgqvzXjagzr0Xf1TrtOGwjrzmuZ8KHPFBC+3vd3Q='
WHERE
key_id = '30980d17bd17809f4cb3872a774626b64072ced689876157d172a0320a5652c0'
AND (
token = 'gX9pgqvzXjagzr0Xf1TrtOGwjrzmuZ8KHPFBC+3vd3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)