UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '65dm+5uTnv4iUF+RiJaK8xqL1NJoaRAwso4KXwYcY4k='
WHERE
key_id = 'a9b01d3b62a9c9ed5f0e9774c3cc864aeb5a55dbafcd6076c653c813419290f0'
AND (
token = '65dm+5uTnv4iUF+RiJaK8xqL1NJoaRAwso4KXwYcY4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)