UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Go6RpxTJoZoqvlHt6y5kp+0fVcy9TT2VuTqU3i9FPM='
WHERE
key_id = '9d078fa6b9054f5488cbf9832510f5fc2b3a2831b42060ae3e866ae950a3aef1'
AND (
token = '3Go6RpxTJoZoqvlHt6y5kp+0fVcy9TT2VuTqU3i9FPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)