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