UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o//0paUlmw9lqKNsxpYFm0zAUX166ZA23nhygD8pyYk='
WHERE
key_id = '0fb49396843132949cb2e35f5f1d59a1c365d615f020e48b37cff6392b0d58dd'
AND (
token = 'o//0paUlmw9lqKNsxpYFm0zAUX166ZA23nhygD8pyYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)