UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0CK4zyY1Vwpn2QLvCUvlVUiNW+jR4r0zW2YCzWKZjZE='
WHERE
key_id = 'ef5a584fb2bfbfda632b5bdae994ea14f40c898842f8f1a606877922cceed3c5'
AND (
token = '0CK4zyY1Vwpn2QLvCUvlVUiNW+jR4r0zW2YCzWKZjZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)