UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9nZzThbPjo3gG/q+bEheHqahMUMt2cqSP2MLF31Zxw='
WHERE
key_id = '71ce14eeb28936a4365b9f6f721a76c379d1d07075590398ae7b88dfacb52460'
AND (
token = 'z9nZzThbPjo3gG/q+bEheHqahMUMt2cqSP2MLF31Zxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)