UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WzIuLq9+U2h2LD0TERCRR7sz8Ec+ocSGFCryk+p/zcI='
WHERE
key_id = 'dac4324881221bfd652565cc37e4a4450604152009f6e1982193080a337e09a0'
AND (
token = 'WzIuLq9+U2h2LD0TERCRR7sz8Ec+ocSGFCryk+p/zcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)