UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKR27B5HwK5yvCR1iT0l2/hQp4vqFx+ngqsyWwpEyyE='
WHERE
key_id = '0e454f3dc2aa10b63189c13b2076a0cb8930462bf0800fa762694dcf6bd52df5'
AND (
token = 'zKR27B5HwK5yvCR1iT0l2/hQp4vqFx+ngqsyWwpEyyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)