UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/5tYMsy9nZL4eUqsRXbARAuWZWJcy8GHhUrIJcfiX7I='
WHERE
key_id = '118cdba42f7a25ca33349c6a52325dce90fadfae52f608a33a9ae9606fde14dd'
AND (
token = '/5tYMsy9nZL4eUqsRXbARAuWZWJcy8GHhUrIJcfiX7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)