UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GiW3RgdU1WYuKEpR6LErh6RkA9+bpBXTlnguMDbmEok='
WHERE
key_id = '0e81b389fa4cf7dca74d1e63f2dc233231d00196e58ecead0ff443daefa4d37f'
AND (
token = 'GiW3RgdU1WYuKEpR6LErh6RkA9+bpBXTlnguMDbmEok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)