UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tw+MdPOXx5cY1nIoLdjGARysdlV4bWwfAbv5E9t4b5g='
WHERE
key_id = 'db778a9cfe4b6f83f992b161b00411aff845d65c1881103ba1282c8038e0da8a'
AND (
token = 'Tw+MdPOXx5cY1nIoLdjGARysdlV4bWwfAbv5E9t4b5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)