UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ZXsKXx4f5Zap70OfsPgFhUbUw7F8X2xNf1sz31s8iI='
WHERE
key_id = 'a47dc867bec22e97e11c43fa837564b9388899e00d9381107da93b030c589b36'
AND (
token = '6ZXsKXx4f5Zap70OfsPgFhUbUw7F8X2xNf1sz31s8iI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)