UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KaiGnkyv2rKWdaTSfQ0UY+74Gpf9TQUY7+9fe0/5SBU='
WHERE
key_id = 'b6a178aefa30a4979bf9f9f112e9f910e094c45ac6b63efc5f89d158575c37c3'
AND (
token = 'KaiGnkyv2rKWdaTSfQ0UY+74Gpf9TQUY7+9fe0/5SBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)