UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qP46xpFoAR3MmJdNOaD4EVclZteMJ8eWUNPIII8OSjg='
WHERE
key_id = 'bfabf6d87af7e683d34ae13e44fe89094124300e6a3017199c3064e2675c1819'
AND (
token = 'qP46xpFoAR3MmJdNOaD4EVclZteMJ8eWUNPIII8OSjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)