UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8x7mkjMi+FX5/Qxk3qqN19ydju7JB/bpBBI0VwzLrhY='
WHERE
key_id = '09417356727e6262e9dfbc2e20c27335519205dcc88df9d508604524ed015387'
AND (
token = '8x7mkjMi+FX5/Qxk3qqN19ydju7JB/bpBBI0VwzLrhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)