UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6uZCz2jFqamhVt5VCBLqzg06SJKn4qEybpRSAVeXB0g='
WHERE
key_id = '7ee3f1b6bb3dab38a852339c17c99a349cb4d2d1f9d50c2d170fed5de833a593'
AND (
token = '6uZCz2jFqamhVt5VCBLqzg06SJKn4qEybpRSAVeXB0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)